Pandas Profiling Report

Dataset statistics

Number of variables	27
Number of observations	9994
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	1
Duplicate rows (%)	< 0.1%
Total size in memory	10.5 MiB
Average record size in memory	1.1 KiB

Variable types

Categorical	15
DateTime	2
Numeric	10

Alerts

Dataset has 1 (< 0.1%) duplicate rows	Duplicates
`order_id` has a high cardinality: 5009 distinct values	High cardinality
`customer_id` has a high cardinality: 793 distinct values	High cardinality
`customer_name` has a high cardinality: 793 distinct values	High cardinality
`city` has a high cardinality: 531 distinct values	High cardinality
`product_id` has a high cardinality: 1862 distinct values	High cardinality
`product_name` has a high cardinality: 1850 distinct values	High cardinality
`sales` is highly overall correlated with `profit` and 3 other fields	High correlation
`discount` is highly overall correlated with `profit` and 1 other fields	High correlation
`profit` is highly overall correlated with `sales` and 2 other fields	High correlation
`no_of_days_for_shipping` is highly overall correlated with `ship_mode`	High correlation
`sale_price_per_unit` is highly overall correlated with `sales` and 3 other fields	High correlation
`profit_per_unit` is highly overall correlated with `discount` and 2 other fields	High correlation
`purchase_price_per_unit` is highly overall correlated with `sales` and 2 other fields	High correlation
`purchase_price` is highly overall correlated with `sales` and 2 other fields	High correlation
`month` is highly overall correlated with `month_name`	High correlation
`ship_mode` is highly overall correlated with `no_of_days_for_shipping`	High correlation
`state` is highly overall correlated with `region`	High correlation
`region` is highly overall correlated with `state`	High correlation
`category` is highly overall correlated with `sub-category`	High correlation
`sub-category` is highly overall correlated with `category`	High correlation
`month_name` is highly overall correlated with `month`	High correlation
`discount` has 4798 (48.0%) zeros	Zeros
`no_of_days_for_shipping` has 519 (5.2%) zeros	Zeros

Reproduction

Analysis started	2023-06-13 02:03:50.441492
Analysis finished	2023-06-13 02:04:17.928480
Duration	27.49 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

order_id
Categorical

Distinct	5009
Distinct (%)	50.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

CA-2017-100111	14
CA-2017-157987	12
CA-2016-165330	11
US-2016-108504	11
CA-2015-131338	10
Other values (5004)	9936

Length

Max length	14
Median length	14
Mean length	14
Min length	14

Characters and Unicode

Total characters	139916
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2538 ?
Unique (%)	25.4%

Sample

1st row	CA-2016-152156
2nd row	CA-2016-152156
3rd row	CA-2016-138688
4th row	US-2015-108966
5th row	US-2015-108966

Common Values

Value	Count	Frequency (%)
CA-2017-100111	14	0.1%
CA-2017-157987	12	0.1%
CA-2016-165330	11	0.1%
US-2016-108504	11	0.1%
CA-2015-131338	10	0.1%
CA-2016-105732	10	0.1%
US-2015-126977	10	0.1%
US-2016-114013	9	0.1%
CA-2014-106439	9	0.1%
CA-2016-145177	9	0.1%
Other values (4999)	9889	98.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ca-2017-100111	14	0.1%
ca-2017-157987	12	0.1%
ca-2016-165330	11	0.1%
us-2016-108504	11	0.1%
ca-2015-131338	10	0.1%
ca-2016-105732	10	0.1%
us-2015-126977	10	0.1%
us-2015-163433	9	0.1%
ca-2017-140949	9	0.1%
ca-2015-158421	9	0.1%
Other values (4999)	9889	98.9%

Most occurring characters

Value	Count	Frequency (%)
1	25510	18.2%
-	19988	14.3%
0	15492	11.1%
2	15381	11.0%
C	8308	5.9%
A	8308	5.9%
6	7904	5.6%
7	7438	5.3%
4	7400	5.3%
5	7338	5.2%
Other values (5)	16849	12.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	99940	71.4%
Dash Punctuation	19988	14.3%
Uppercase Letter	19988	14.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	25510	25.5%
0	15492	15.5%
2	15381	15.4%
6	7904	7.9%
7	7438	7.4%
4	7400	7.4%
5	7338	7.3%
3	5449	5.5%
8	4042	4.0%
9	3986	4.0%

Uppercase Letter

Value	Count	Frequency (%)
C	8308	41.6%
A	8308	41.6%
U	1686	8.4%
S	1686	8.4%

Dash Punctuation

Value	Count	Frequency (%)
-	19988	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	119928	85.7%
Latin	19988	14.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	25510	21.3%
-	19988	16.7%
0	15492	12.9%
2	15381	12.8%
6	7904	6.6%
7	7438	6.2%
4	7400	6.2%
5	7338	6.1%
3	5449	4.5%
8	4042	3.4%

Latin

Value	Count	Frequency (%)
C	8308	41.6%
A	8308	41.6%
U	1686	8.4%
S	1686	8.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	139916	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	25510	18.2%
-	19988	14.3%
0	15492	11.1%
2	15381	11.0%
C	8308	5.9%
A	8308	5.9%
6	7904	5.6%
7	7438	5.3%
4	7400	5.3%
5	7338	5.2%
Other values (5)	16849	12.0%

order_date
Date

Distinct	1237
Distinct (%)	12.4%
Missing	0
Missing (%)	0.0%
Memory size	414.2 KiB

Minimum	2014-01-03 00:00:00
Maximum	2017-12-30 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

ship_date
Date

Distinct	1329
Distinct (%)	13.3%
Missing	0
Missing (%)	0.0%
Memory size	414.2 KiB

Minimum	2014-01-07 00:00:00
Maximum	2017-12-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

ship_mode
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1017.6 KiB

Standard Class	5968
Second Class	1945
First Class	1538
Same Day	543

Length

Max length	14
Median length	14
Mean length	12.823094
Min length	8

Characters and Unicode

Total characters	128154
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Second Class
2nd row	Second Class
3rd row	Second Class
4th row	Standard Class
5th row	Standard Class

Common Values

Value	Count	Frequency (%)
Standard Class	5968	59.7%
Second Class	1945	19.5%
First Class	1538	15.4%
Same Day	543	5.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
class	9451	47.3%
standard	5968	29.9%
second	1945	9.7%
first	1538	7.7%
same	543	2.7%
day	543	2.7%

Most occurring characters

Value	Count	Frequency (%)
a	22473	17.5%
s	20440	15.9%
d	13881	10.8%
	9994	7.8%
l	9451	7.4%
C	9451	7.4%
S	8456	6.6%
n	7913	6.2%
r	7506	5.9%
t	7506	5.9%
Other values (8)	11083	8.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	98172	76.6%
Uppercase Letter	19988	15.6%
Space Separator	9994	7.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	22473	22.9%
s	20440	20.8%
d	13881	14.1%
l	9451	9.6%
n	7913	8.1%
r	7506	7.6%
t	7506	7.6%
e	2488	2.5%
c	1945	2.0%
o	1945	2.0%
Other values (3)	2624	2.7%

Uppercase Letter

Value	Count	Frequency (%)
C	9451	47.3%
S	8456	42.3%
F	1538	7.7%
D	543	2.7%

Space Separator

Value	Count	Frequency (%)
	9994	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	118160	92.2%
Common	9994	7.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	22473	19.0%
s	20440	17.3%
d	13881	11.7%
l	9451	8.0%
C	9451	8.0%
S	8456	7.2%
n	7913	6.7%
r	7506	6.4%
t	7506	6.4%
e	2488	2.1%
Other values (7)	8595	7.3%

Common

Value	Count	Frequency (%)
	9994	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	128154	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	22473	17.5%
s	20440	15.9%
d	13881	10.8%
	9994	7.8%
l	9451	7.4%
C	9451	7.4%
S	8456	6.6%
n	7913	6.2%
r	7506	5.9%
t	7506	5.9%
Other values (8)	11083	8.6%

customer_id
Categorical

Distinct	793
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Memory size	970.5 KiB

WB-21850	37
JL-15835	34
MA-17560	34
PP-18955	34
CK-12205	32
Other values (788)	9823

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	79952
Distinct characters	40
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	0.1%

Sample

1st row	CG-12520
2nd row	CG-12520
3rd row	DV-13045
4th row	SO-20335
5th row	SO-20335

Common Values

Value	Count	Frequency (%)
WB-21850	37	0.4%
JL-15835	34	0.3%
MA-17560	34	0.3%
PP-18955	34	0.3%
CK-12205	32	0.3%
SV-20365	32	0.3%
JD-15895	32	0.3%
EH-13765	32	0.3%
ZC-21910	31	0.3%
EP-13915	31	0.3%
Other values (783)	9665	96.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
wb-21850	37	0.4%
ma-17560	34	0.3%
pp-18955	34	0.3%
jl-15835	34	0.3%
ck-12205	32	0.3%
sv-20365	32	0.3%
jd-15895	32	0.3%
eh-13765	32	0.3%
zc-21910	31	0.3%
ep-13915	31	0.3%
Other values (783)	9665	96.7%

Most occurring characters

Value	Count	Frequency (%)
1	11915	14.9%
-	9994	12.5%
0	8532	10.7%
5	7865	9.8%
2	4682	5.9%
7	2931	3.7%
6	2909	3.6%
9	2904	3.6%
8	2818	3.5%
3	2779	3.5%
Other values (30)	22623	28.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	49970	62.5%
Uppercase Letter	19945	24.9%
Dash Punctuation	9994	12.5%
Lowercase Letter	43	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	1798	9.0%
C	1725	8.6%
M	1712	8.6%
B	1642	8.2%
D	1296	6.5%
A	1227	6.2%
J	1134	5.7%
P	1105	5.5%
H	968	4.9%
K	932	4.7%
Other values (16)	6406	32.1%

Decimal Number

Value	Count	Frequency (%)
1	11915	23.8%
0	8532	17.1%
5	7865	15.7%
2	4682	9.4%
7	2931	5.9%
6	2909	5.8%
9	2904	5.8%
8	2818	5.6%
3	2779	5.6%
4	2635	5.3%

Lowercase Letter

Value	Count	Frequency (%)
p	29	67.4%
o	8	18.6%
l	6	14.0%

Dash Punctuation

Value	Count	Frequency (%)
-	9994	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	59964	75.0%
Latin	19988	25.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	1798	9.0%
C	1725	8.6%
M	1712	8.6%
B	1642	8.2%
D	1296	6.5%
A	1227	6.1%
J	1134	5.7%
P	1105	5.5%
H	968	4.8%
K	932	4.7%
Other values (19)	6449	32.3%

Common

Value	Count	Frequency (%)
1	11915	19.9%
-	9994	16.7%
0	8532	14.2%
5	7865	13.1%
2	4682	7.8%
7	2931	4.9%
6	2909	4.9%
9	2904	4.8%
8	2818	4.7%
3	2779	4.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	79952	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	11915	14.9%
-	9994	12.5%
0	8532	10.7%
5	7865	9.8%
2	4682	5.9%
7	2931	3.7%
6	2909	3.6%
9	2904	3.6%
8	2818	3.5%
3	2779	3.5%
Other values (30)	22623	28.3%

customer_name
Categorical

Distinct	793
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Memory size	1022.4 KiB

William Brown	37
John Lee	34
Matt Abelman	34
Paul Prost	34
Chloris Kastensmidt	32
Other values (788)	9823

Length

Max length	22
Median length	18
Mean length	12.960676
Min length	7

Characters and Unicode

Total characters	129529
Distinct characters	57
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	0.1%

Sample

1st row	Claire Gute
2nd row	Claire Gute
3rd row	Darrin Van Huff
4th row	Sean O'Donnell
5th row	Sean O'Donnell

Common Values

Value	Count	Frequency (%)
William Brown	37	0.4%
John Lee	34	0.3%
Matt Abelman	34	0.3%
Paul Prost	34	0.3%
Chloris Kastensmidt	32	0.3%
Seth Vernon	32	0.3%
Jonathan Doherty	32	0.3%
Edward Hooks	32	0.3%
Zuschuss Carroll	31	0.3%
Emily Phan	31	0.3%
Other values (783)	9665	96.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
michael	120	0.6%
frank	112	0.6%
john	107	0.5%
patrick	96	0.5%
brian	93	0.5%
stewart	93	0.5%
paul	92	0.5%
ken	91	0.5%
rick	91	0.5%
matt	86	0.4%
Other values (901)	19072	95.1%

Most occurring characters

Value	Count	Frequency (%)
a	12011	9.3%
e	11836	9.1%
n	10241	7.9%
	10059	7.8%
r	9530	7.4%
i	7919	6.1%
l	6494	5.0%
o	5850	4.5%
t	5435	4.2%
s	4546	3.5%
Other values (47)	45608	35.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	98856	76.3%
Uppercase Letter	20461	15.8%
Space Separator	10059	7.8%
Other Punctuation	124	0.1%
Dash Punctuation	29	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	12011	12.1%
e	11836	12.0%
n	10241	10.4%
r	9530	9.6%
i	7919	8.0%
l	6494	6.6%
o	5850	5.9%
t	5435	5.5%
s	4546	4.6%
h	3857	3.9%
Other values (18)	21137	21.4%

Uppercase Letter

Value	Count	Frequency (%)
C	1830	8.9%
S	1798	8.8%
M	1749	8.5%
B	1696	8.3%
D	1325	6.5%
A	1282	6.3%
J	1134	5.5%
P	1105	5.4%
H	1005	4.9%
K	964	4.7%
Other values (16)	6573	32.1%

Space Separator

Value	Count	Frequency (%)
	10059	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	124	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	29	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	119317	92.1%
Common	10212	7.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	12011	10.1%
e	11836	9.9%
n	10241	8.6%
r	9530	8.0%
i	7919	6.6%
l	6494	5.4%
o	5850	4.9%
t	5435	4.6%
s	4546	3.8%
h	3857	3.2%
Other values (44)	41598	34.9%

Common

Value	Count	Frequency (%)
	10059	98.5%
'	124	1.2%
-	29	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	129440	99.9%
None	89	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	12011	9.3%
e	11836	9.1%
n	10241	7.9%
	10059	7.8%
r	9530	7.4%
i	7919	6.1%
l	6494	5.0%
o	5850	4.5%
t	5435	4.2%
s	4546	3.5%
Other values (44)	45519	35.2%

None

Value	Count	Frequency (%)
ö	61	68.5%
ä	23	25.8%
ü	5	5.6%

segment
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	978.7 KiB

Consumer	5191
Corporate	3020
Home Office	1783

Length

Max length	11
Median length	8
Mean length	8.8374024
Min length	8

Characters and Unicode

Total characters	88321
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Consumer
2nd row	Consumer
3rd row	Corporate
4th row	Consumer
5th row	Consumer

Common Values

Value	Count	Frequency (%)
Consumer	5191	51.9%
Corporate	3020	30.2%
Home Office	1783	17.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
consumer	5191	44.1%
corporate	3020	25.6%
home	1783	15.1%
office	1783	15.1%

Most occurring characters

Value	Count	Frequency (%)
o	13014	14.7%
e	11777	13.3%
r	11231	12.7%
C	8211	9.3%
m	6974	7.9%
n	5191	5.9%
s	5191	5.9%
u	5191	5.9%
f	3566	4.0%
t	3020	3.4%
Other values (7)	14955	16.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	74761	84.6%
Uppercase Letter	11777	13.3%
Space Separator	1783	2.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	13014	17.4%
e	11777	15.8%
r	11231	15.0%
m	6974	9.3%
n	5191	6.9%
s	5191	6.9%
u	5191	6.9%
f	3566	4.8%
t	3020	4.0%
p	3020	4.0%
Other values (3)	6586	8.8%

Uppercase Letter

Value	Count	Frequency (%)
C	8211	69.7%
H	1783	15.1%
O	1783	15.1%

Space Separator

Value	Count	Frequency (%)
	1783	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	86538	98.0%
Common	1783	2.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	13014	15.0%
e	11777	13.6%
r	11231	13.0%
C	8211	9.5%
m	6974	8.1%
n	5191	6.0%
s	5191	6.0%
u	5191	6.0%
f	3566	4.1%
t	3020	3.5%
Other values (6)	13172	15.2%

Common

Value	Count	Frequency (%)
	1783	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	88321	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	13014	14.7%
e	11777	13.3%
r	11231	12.7%
C	8211	9.3%
m	6974	7.9%
n	5191	5.9%
s	5191	5.9%
u	5191	5.9%
f	3566	4.0%
t	3020	3.4%
Other values (7)	14955	16.9%

city
Categorical

Distinct	531
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Memory size	983.5 KiB

New York City	915
Los Angeles	747
Philadelphia	537
San Francisco	510
Seattle	428
Other values (526)	6857

Length

Max length	17
Median length	14
Mean length	9.3306984
Min length	4

Characters and Unicode

Total characters	93251
Distinct characters	51
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	70 ?
Unique (%)	0.7%

Sample

1st row	Henderson
2nd row	Henderson
3rd row	Los Angeles
4th row	Fort Lauderdale
5th row	Fort Lauderdale

Common Values

Value	Count	Frequency (%)
New York City	915	9.2%
Los Angeles	747	7.5%
Philadelphia	537	5.4%
San Francisco	510	5.1%
Seattle	428	4.3%
Houston	377	3.8%
Chicago	314	3.1%
Columbus	222	2.2%
San Diego	170	1.7%
Springfield	163	1.6%
Other values (521)	5611	56.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
city	994	7.0%
new	937	6.6%
york	920	6.5%
san	805	5.7%
los	747	5.2%
angeles	747	5.2%
philadelphia	537	3.8%
francisco	510	3.6%
seattle	428	3.0%
houston	377	2.6%
Other values (555)	7234	50.8%

Most occurring characters

Value	Count	Frequency (%)
e	8719	9.4%
a	7591	8.1%
o	7499	8.0%
i	6229	6.7%
n	6199	6.6%
l	5986	6.4%
s	4699	5.0%
r	4468	4.8%
t	4438	4.8%
	4242	4.5%
Other values (41)	33181	35.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	74773	80.2%
Uppercase Letter	14236	15.3%
Space Separator	4242	4.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	8719	11.7%
a	7591	10.2%
o	7499	10.0%
i	6229	8.3%
n	6199	8.3%
l	5986	8.0%
s	4699	6.3%
r	4468	6.0%
t	4438	5.9%
c	2393	3.2%
Other values (16)	16552	22.1%

Uppercase Letter

Value	Count	Frequency (%)
C	2085	14.6%
S	1740	12.2%
L	1295	9.1%
A	1242	8.7%
N	1134	8.0%
P	1013	7.1%
Y	940	6.6%
F	794	5.6%
D	627	4.4%
H	617	4.3%
Other values (14)	2749	19.3%

Space Separator

Value	Count	Frequency (%)
	4242	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	89009	95.5%
Common	4242	4.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	8719	9.8%
a	7591	8.5%
o	7499	8.4%
i	6229	7.0%
n	6199	7.0%
l	5986	6.7%
s	4699	5.3%
r	4468	5.0%
t	4438	5.0%
c	2393	2.7%
Other values (40)	30788	34.6%

Common

Value	Count	Frequency (%)
	4242	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	93251	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	8719	9.4%
a	7591	8.1%
o	7499	8.0%
i	6229	6.7%
n	6199	6.6%
l	5986	6.4%
s	4699	5.0%
r	4468	4.8%
t	4438	4.8%
	4242	4.5%
Other values (41)	33181	35.6%

state
Categorical

Distinct	49
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	975.3 KiB

California	2001
New York	1128
Texas	985
Pennsylvania	587
Washington	506
Other values (44)	4787

Length

Max length	20
Median length	14
Mean length	8.4871923
Min length	4

Characters and Unicode

Total characters	84821
Distinct characters	46
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Kentucky
2nd row	Kentucky
3rd row	California
4th row	Florida
5th row	Florida

Common Values

Value	Count	Frequency (%)
California	2001	20.0%
New York	1128	11.3%
Texas	985	9.9%
Pennsylvania	587	5.9%
Washington	506	5.1%
Illinois	492	4.9%
Ohio	469	4.7%
Florida	383	3.8%
Michigan	255	2.6%
North Carolina	249	2.5%
Other values (39)	2939	29.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
california	2001	17.1%
new	1322	11.3%
york	1128	9.6%
texas	985	8.4%
pennsylvania	587	5.0%
washington	506	4.3%
illinois	492	4.2%
ohio	469	4.0%
florida	383	3.3%
carolina	291	2.5%
Other values (43)	3542	30.3%

Most occurring characters

Value	Count	Frequency (%)
a	10758	12.7%
i	9895	11.7%
n	8090	9.5%
o	7323	8.6%
r	5544	6.5%
e	5051	6.0%
l	4822	5.7%
s	4604	5.4%
C	2566	3.0%
f	2011	2.4%
Other values (36)	24157	28.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	71413	84.2%
Uppercase Letter	11696	13.8%
Space Separator	1712	2.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	10758	15.1%
i	9895	13.9%
n	8090	11.3%
o	7323	10.3%
r	5544	7.8%
e	5051	7.1%
l	4822	6.8%
s	4604	6.4%
f	2011	2.8%
h	1898	2.7%
Other values (14)	11417	16.0%

Uppercase Letter

Value	Count	Frequency (%)
C	2566	21.9%
N	1655	14.2%
T	1168	10.0%
Y	1128	9.6%
M	763	6.5%
I	748	6.4%
O	659	5.6%
W	621	5.3%
P	587	5.0%
F	383	3.3%
Other values (11)	1418	12.1%

Space Separator

Value	Count	Frequency (%)
	1712	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	83109	98.0%
Common	1712	2.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	10758	12.9%
i	9895	11.9%
n	8090	9.7%
o	7323	8.8%
r	5544	6.7%
e	5051	6.1%
l	4822	5.8%
s	4604	5.5%
C	2566	3.1%
f	2011	2.4%
Other values (35)	22445	27.0%

Common

Value	Count	Frequency (%)
	1712	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	84821	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	10758	12.7%
i	9895	11.7%
n	8090	9.5%
o	7323	8.6%
r	5544	6.5%
e	5051	6.0%
l	4822	5.7%
s	4604	5.4%
C	2566	3.0%
f	2011	2.4%
Other values (36)	24157	28.5%

region
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	939.9 KiB

West	3203
East	2848
Central	2323
South	1620

Length

Max length	7
Median length	4
Mean length	4.8594156
Min length	4

Characters and Unicode

Total characters	48565
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	South
2nd row	South
3rd row	West
4th row	South
5th row	South

Common Values

Value	Count	Frequency (%)
West	3203	32.0%
East	2848	28.5%
Central	2323	23.2%
South	1620	16.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
west	3203	32.0%
east	2848	28.5%
central	2323	23.2%
south	1620	16.2%

Most occurring characters

Value	Count	Frequency (%)
t	9994	20.6%
s	6051	12.5%
e	5526	11.4%
a	5171	10.6%
W	3203	6.6%
E	2848	5.9%
C	2323	4.8%
n	2323	4.8%
r	2323	4.8%
l	2323	4.8%
Other values (4)	6480	13.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	38571	79.4%
Uppercase Letter	9994	20.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	9994	25.9%
s	6051	15.7%
e	5526	14.3%
a	5171	13.4%
n	2323	6.0%
r	2323	6.0%
l	2323	6.0%
o	1620	4.2%
u	1620	4.2%
h	1620	4.2%

Uppercase Letter

Value	Count	Frequency (%)
W	3203	32.0%
E	2848	28.5%
C	2323	23.2%
S	1620	16.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	48565	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	9994	20.6%
s	6051	12.5%
e	5526	11.4%
a	5171	10.6%
W	3203	6.6%
E	2848	5.9%
C	2323	4.8%
n	2323	4.8%
r	2323	4.8%
l	2323	4.8%
Other values (4)	6480	13.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	48565	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	9994	20.6%
s	6051	12.5%
e	5526	11.4%
a	5171	10.6%
W	3203	6.6%
E	2848	5.9%
C	2323	4.8%
n	2323	4.8%
r	2323	4.8%
l	2323	4.8%
Other values (4)	6480	13.3%

product_id
Categorical

Distinct	1862
Distinct (%)	18.6%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

OFF-PA-10001970	19
TEC-AC-10003832	18
FUR-FU-10004270	16
FUR-CH-10001146	15
TEC-AC-10003628	15
Other values (1857)	9911

Length

Max length	15
Median length	15
Mean length	15
Min length	15

Characters and Unicode

Total characters	149910
Distinct characters	27
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	91 ?
Unique (%)	0.9%

Sample

1st row	FUR-BO-10001798
2nd row	FUR-CH-10000454
3rd row	OFF-LA-10000240
4th row	FUR-TA-10000577
5th row	OFF-ST-10000760

Common Values

Value	Count	Frequency (%)
OFF-PA-10001970	19	0.2%
TEC-AC-10003832	18	0.2%
FUR-FU-10004270	16	0.2%
FUR-CH-10001146	15	0.2%
TEC-AC-10003628	15	0.2%
FUR-CH-10002647	15	0.2%
TEC-AC-10002049	15	0.2%
OFF-BI-10004632	14	0.1%
OFF-BI-10001524	14	0.1%
FUR-CH-10002880	14	0.1%
Other values (1852)	9839	98.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
off-pa-10001970	19	0.2%
tec-ac-10003832	18	0.2%
fur-fu-10004270	16	0.2%
fur-ch-10001146	15	0.2%
tec-ac-10003628	15	0.2%
fur-ch-10002647	15	0.2%
tec-ac-10002049	15	0.2%
off-pa-10002377	14	0.1%
fur-ch-10003774	14	0.1%
off-bi-10002026	14	0.1%
Other values (1852)	9839	98.4%

Most occurring characters

Value	Count	Frequency (%)
0	35052	23.4%
-	19988	13.3%
F	15347	10.2%
1	14995	10.0%
O	6322	4.2%
2	4862	3.2%
4	4831	3.2%
3	4805	3.2%
A	4422	2.9%
5	3401	2.3%
Other values (17)	35885	23.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	79952	53.3%
Uppercase Letter	49970	33.3%
Dash Punctuation	19988	13.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
F	15347	30.7%
O	6322	12.7%
A	4422	8.8%
C	3307	6.6%
U	3268	6.5%
T	3012	6.0%
R	2917	5.8%
P	2725	5.5%
E	2101	4.2%
B	1751	3.5%
Other values (6)	4798	9.6%

Decimal Number

Value	Count	Frequency (%)
0	35052	43.8%
1	14995	18.8%
2	4862	6.1%
4	4831	6.0%
3	4805	6.0%
5	3401	4.3%
7	3103	3.9%
9	3051	3.8%
6	2999	3.8%
8	2853	3.6%

Dash Punctuation

Value	Count	Frequency (%)
-	19988	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	99940	66.7%
Latin	49970	33.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
F	15347	30.7%
O	6322	12.7%
A	4422	8.8%
C	3307	6.6%
U	3268	6.5%
T	3012	6.0%
R	2917	5.8%
P	2725	5.5%
E	2101	4.2%
B	1751	3.5%
Other values (6)	4798	9.6%

Common

Value	Count	Frequency (%)
0	35052	35.1%
-	19988	20.0%
1	14995	15.0%
2	4862	4.9%
4	4831	4.8%
3	4805	4.8%
5	3401	3.4%
7	3103	3.1%
9	3051	3.1%
6	2999	3.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	149910	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	35052	23.4%
-	19988	13.3%
F	15347	10.2%
1	14995	10.0%
O	6322	4.2%
2	4862	3.2%
4	4831	3.2%
3	4805	3.2%
A	4422	2.9%
5	3401	2.3%
Other values (17)	35885	23.9%

category
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1017.4 KiB

Office Supplies	6026
Furniture	2121
Technology	1847

Length

Max length	15
Median length	15
Mean length	12.802582
Min length	9

Characters and Unicode

Total characters	127949
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Furniture
2nd row	Furniture
3rd row	Office Supplies
4th row	Furniture
5th row	Office Supplies

Common Values

Value	Count	Frequency (%)
Office Supplies	6026	60.3%
Furniture	2121	21.2%
Technology	1847	18.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
office	6026	37.6%
supplies	6026	37.6%
furniture	2121	13.2%
technology	1847	11.5%

Most occurring characters

Value	Count	Frequency (%)
e	16020	12.5%
i	14173	11.1%
p	12052	9.4%
f	12052	9.4%
u	10268	8.0%
c	7873	6.2%
l	7873	6.2%
O	6026	4.7%
s	6026	4.7%
S	6026	4.7%
Other values (10)	29560	23.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	105903	82.8%
Uppercase Letter	16020	12.5%
Space Separator	6026	4.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	16020	15.1%
i	14173	13.4%
p	12052	11.4%
f	12052	11.4%
u	10268	9.7%
c	7873	7.4%
l	7873	7.4%
s	6026	5.7%
r	4242	4.0%
n	3968	3.7%
Other values (5)	11356	10.7%

Uppercase Letter

Value	Count	Frequency (%)
O	6026	37.6%
S	6026	37.6%
F	2121	13.2%
T	1847	11.5%

Space Separator

Value	Count	Frequency (%)
	6026	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	121923	95.3%
Common	6026	4.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	16020	13.1%
i	14173	11.6%
p	12052	9.9%
f	12052	9.9%
u	10268	8.4%
c	7873	6.5%
l	7873	6.5%
O	6026	4.9%
s	6026	4.9%
S	6026	4.9%
Other values (9)	23534	19.3%

Common

Value	Count	Frequency (%)
	6026	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	127949	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	16020	12.5%
i	14173	11.1%
p	12052	9.4%
f	12052	9.4%
u	10268	8.0%
c	7873	6.2%
l	7873	6.2%
O	6026	4.7%
s	6026	4.7%
S	6026	4.7%
Other values (10)	29560	23.1%

sub-category
Categorical

Distinct	17
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	962.6 KiB

Binders	1523
Paper	1370
Furnishings	957
Phones	889
Storage	846
Other values (12)	4409

Length

Max length	11
Median length	9
Mean length	7.191715
Min length	3

Characters and Unicode

Total characters	71874
Distinct characters	28
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Bookcases
2nd row	Chairs
3rd row	Labels
4th row	Tables
5th row	Storage

Common Values

Value	Count	Frequency (%)
Binders	1523	15.2%
Paper	1370	13.7%
Furnishings	957	9.6%
Phones	889	8.9%
Storage	846	8.5%
Art	796	8.0%
Accessories	775	7.8%
Chairs	617	6.2%
Appliances	466	4.7%
Labels	364	3.6%
Other values (7)	1391	13.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
binders	1523	15.2%
paper	1370	13.7%
furnishings	957	9.6%
phones	889	8.9%
storage	846	8.5%
art	796	8.0%
accessories	775	7.8%
chairs	617	6.2%
appliances	466	4.7%
labels	364	3.6%
Other values (7)	1391	13.9%

Most occurring characters

Value	Count	Frequency (%)
s	9934	13.8%
e	8870	12.3%
r	7169	10.0%
i	5668	7.9%
n	5378	7.5%
a	4542	6.3%
o	3288	4.6%
p	3004	4.2%
h	2578	3.6%
c	2359	3.3%
Other values (18)	19084	26.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	61880	86.1%
Uppercase Letter	9994	13.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	9934	16.1%
e	8870	14.3%
r	7169	11.6%
i	5668	9.2%
n	5378	8.7%
a	4542	7.3%
o	3288	5.3%
p	3004	4.9%
h	2578	4.2%
c	2359	3.8%
Other values (8)	9090	14.7%

Uppercase Letter

Value	Count	Frequency (%)
P	2259	22.6%
A	2037	20.4%
B	1751	17.5%
F	1174	11.7%
S	1036	10.4%
C	685	6.9%
L	364	3.6%
T	319	3.2%
E	254	2.5%
M	115	1.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	71874	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	9934	13.8%
e	8870	12.3%
r	7169	10.0%
i	5668	7.9%
n	5378	7.5%
a	4542	6.3%
o	3288	4.6%
p	3004	4.2%
h	2578	3.6%
c	2359	3.3%
Other values (18)	19084	26.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	71874	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	9934	13.8%
e	8870	12.3%
r	7169	10.0%
i	5668	7.9%
n	5378	7.5%
a	4542	6.3%
o	3288	4.6%
p	3004	4.2%
h	2578	3.6%
c	2359	3.3%
Other values (18)	19084	26.6%

product_name
Categorical

Distinct	1850
Distinct (%)	18.5%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Staple envelope	48
Staples	46
Easy-staple paper	46
Avery Non-Stick Binders	20
Staples in misc. colors	19
Other values (1845)	9815

Length

Max length	127
Median length	78
Mean length	36.91605
Min length	5

Characters and Unicode

Total characters	368939
Distinct characters	85
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	91 ?
Unique (%)	0.9%

Sample

1st row	Bush Somerset Collection Bookcase
2nd row	Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back
3rd row	Self-Adhesive Address Labels for Typewriters by Universal
4th row	Bretford CR4500 Series Slim Rectangular Table
5th row	Eldon Fold 'N Roll Cart System

Common Values

Value	Count	Frequency (%)
Staple envelope	48	0.5%
Staples	46	0.5%
Easy-staple paper	46	0.5%
Avery Non-Stick Binders	20	0.2%
Staples in misc. colors	19	0.2%
Staple remover	18	0.2%
KI Adjustable-Height Table	18	0.2%
Storex Dura Pro Binders	17	0.2%
Staple-based wall hangings	16	0.2%
Logitech 910-002974 M325 Wireless Mouse for Web Scrolling	15	0.2%
Other values (1840)	9731	97.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
xerox	865	1.5%
x	701	1.3%
	599	1.1%
with	599	1.1%
avery	557	1.0%
for	539	1.0%
binders	524	0.9%
chair	479	0.9%
black	426	0.8%
phone	374	0.7%
Other values (2798)	50371	89.9%

Most occurring characters

Value	Count	Frequency (%)
	45670	12.4%
e	33538	9.1%
r	20791	5.6%
o	19902	5.4%
a	19064	5.2%
i	18648	5.1%
l	16365	4.4%
n	15622	4.2%
s	14683	4.0%
t	14550	3.9%
Other values (75)	150106	40.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	238253	64.6%
Uppercase Letter	56270	15.3%
Space Separator	46097	12.5%
Decimal Number	17981	4.9%
Other Punctuation	7152	1.9%
Dash Punctuation	2940	0.8%
Control	86	< 0.1%
Close Punctuation	60	< 0.1%
Open Punctuation	60	< 0.1%
Math Symbol	35	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	33538	14.1%
r	20791	8.7%
o	19902	8.4%
a	19064	8.0%
i	18648	7.8%
l	16365	6.9%
n	15622	6.6%
s	14683	6.2%
t	14550	6.1%
c	8924	3.7%
Other values (18)	56166	23.6%

Uppercase Letter

Value	Count	Frequency (%)
S	6281	11.2%
C	6007	10.7%
B	5530	9.8%
P	4918	8.7%
A	2948	5.2%
D	2941	5.2%
M	2870	5.1%
T	2616	4.6%
F	2510	4.5%
L	2284	4.1%
Other values (16)	17365	30.9%

Other Punctuation

Value	Count	Frequency (%)
,	3120	43.6%
/	1561	21.8%
"	1300	18.2%
.	463	6.5%
&	287	4.0%
'	257	3.6%
#	90	1.3%
%	45	0.6%
*	9	0.1%
!	9	0.1%
Other values (2)	11	0.2%

Decimal Number

Value	Count	Frequency (%)
1	3783	21.0%
0	2921	16.2%
2	2270	12.6%
4	1725	9.6%
3	1530	8.5%
5	1443	8.0%
8	1254	7.0%
9	1234	6.9%
6	941	5.2%
7	880	4.9%

Space Separator

Value	Count	Frequency (%)
	45670	99.1%
	427	0.9%

Control

Value	Count	Frequency (%)
	67	77.9%
	19	22.1%

Dash Punctuation

Value	Count	Frequency (%)
-	2940	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	60	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	60	100.0%

Math Symbol

Value	Count	Frequency (%)
+	35	100.0%

Other Number

Value	Count	Frequency (%)
¾	5	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	294523	79.8%
Common	74416	20.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	33538	11.4%
r	20791	7.1%
o	19902	6.8%
a	19064	6.5%
i	18648	6.3%
l	16365	5.6%
n	15622	5.3%
s	14683	5.0%
t	14550	4.9%
c	8924	3.0%
Other values (44)	112436	38.2%

Common

Value	Count	Frequency (%)
	45670	61.4%
1	3783	5.1%
,	3120	4.2%
-	2940	4.0%
0	2921	3.9%
2	2270	3.1%
4	1725	2.3%
/	1561	2.1%
3	1530	2.1%
5	1443	1.9%
Other values (21)	7453	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	368404	99.9%
None	535	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	45670	12.4%
e	33538	9.1%
r	20791	5.6%
o	19902	5.4%
a	19064	5.2%
i	18648	5.1%
l	16365	4.4%
n	15622	4.2%
s	14683	4.0%
t	14550	3.9%
Other values (69)	149571	40.6%

None

Value	Count	Frequency (%)
	427	79.8%
	67	12.5%
	19	3.6%
é	14	2.6%
¾	5	0.9%
à	3	0.6%

sales
Real number (ℝ)

Distinct	5825
Distinct (%)	58.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	229.858

Minimum	0.444
Maximum	22638.48
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	414.2 KiB

Quantile statistics

Minimum	0.444
5-th percentile	4.98
Q1	17.28
median	54.49
Q3	209.94
95-th percentile	956.98425
Maximum	22638.48
Range	22638.036
Interquartile range (IQR)	192.66

Descriptive statistics

Standard deviation	623.2451
Coefficient of variation (CV)	2.7114353
Kurtosis	305.31175
Mean	229.858
Median Absolute Deviation (MAD)	45.406
Skewness	12.972752
Sum	2297200.9
Variance	388434.46
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12.96	56	0.6%
19.44	39	0.4%
15.552	39	0.4%
25.92	36	0.4%
10.368	36	0.4%
32.4	28	0.3%
17.94	21	0.2%
6.48	21	0.2%
20.736	19	0.2%
14.94	17	0.2%
Other values (5815)	9682	96.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.444	1	< 0.1%
0.556	1	< 0.1%
0.836	1	< 0.1%
0.852	1	< 0.1%
0.876	1	< 0.1%
0.898	1	< 0.1%
0.984	1	< 0.1%
0.99	1	< 0.1%
1.044	1	< 0.1%
1.08	3	< 0.1%

Value	Count	Frequency (%)
22638.48	1	< 0.1%
17499.95	1	< 0.1%
13999.96	1	< 0.1%
11199.968	1	< 0.1%
10499.97	1	< 0.1%
9892.74	1	< 0.1%
9449.95	1	< 0.1%
9099.93	1	< 0.1%
8749.95	1	< 0.1%
8399.976	1	< 0.1%

quantity
Real number (ℝ)

Distinct	14
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.7895737

Minimum	1
Maximum	14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	414.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	8
Maximum	14
Range	13
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.2251097
Coefficient of variation (CV)	0.58716622
Kurtosis	1.9918894
Mean	3.7895737
Median Absolute Deviation (MAD)	1
Skewness	1.2785448
Sum	37873
Variance	4.9511131
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
3	2409	24.1%
2	2402	24.0%
5	1230	12.3%
4	1191	11.9%
1	899	9.0%
7	606	6.1%
6	572	5.7%
9	258	2.6%
8	257	2.6%
10	57	0.6%
Other values (4)	113	1.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	899	9.0%
2	2402	24.0%
3	2409	24.1%
4	1191	11.9%
5	1230	12.3%
6	572	5.7%
7	606	6.1%
8	257	2.6%
9	258	2.6%
10	57	0.6%

Value	Count	Frequency (%)
14	29	0.3%
13	27	0.3%
12	23	0.2%
11	34	0.3%
10	57	0.6%
9	258	2.6%
8	257	2.6%
7	606	6.1%
6	572	5.7%
5	1230	12.3%

discount
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.15620272

Minimum	0
Maximum	0.8
Zeros	4798
Zeros (%)	48.0%
Negative	0
Negative (%)	0.0%
Memory size	414.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.2
Q3	0.2
95-th percentile	0.7
Maximum	0.8
Range	0.8
Interquartile range (IQR)	0.2

Descriptive statistics

Standard deviation	0.20645197
Coefficient of variation (CV)	1.3216925
Kurtosis	2.4095461
Mean	0.15620272
Median Absolute Deviation (MAD)	0.2
Skewness	1.6842947
Sum	1561.09
Variance	0.042622415
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	4798	48.0%
0.2	3657	36.6%
0.7	418	4.2%
0.8	300	3.0%
0.3	227	2.3%
0.4	206	2.1%
0.6	138	1.4%
0.1	94	0.9%
0.5	66	0.7%
0.15	52	0.5%
Other values (2)	38	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4798	48.0%
0.1	94	0.9%
0.15	52	0.5%
0.2	3657	36.6%
0.3	227	2.3%
0.32	27	0.3%
0.4	206	2.1%
0.45	11	0.1%
0.5	66	0.7%
0.6	138	1.4%

Value	Count	Frequency (%)
0.8	300	3.0%
0.7	418	4.2%
0.6	138	1.4%
0.5	66	0.7%
0.45	11	0.1%
0.4	206	2.1%
0.32	27	0.3%
0.3	227	2.3%
0.2	3657	36.6%
0.15	52	0.5%

profit
Real number (ℝ)

Distinct	7287
Distinct (%)	72.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.656896

Minimum	-6599.978
Maximum	8399.976
Zeros	65
Zeros (%)	0.7%
Negative	1871
Negative (%)	18.7%
Memory size	414.2 KiB

Quantile statistics

Minimum	-6599.978
5-th percentile	-53.03092
Q1	1.72875
median	8.6665
Q3	29.364
95-th percentile	168.4704
Maximum	8399.976
Range	14999.954
Interquartile range (IQR)	27.63525

Descriptive statistics

Standard deviation	234.26011
Coefficient of variation (CV)	8.1746504
Kurtosis	397.18851
Mean	28.656896
Median Absolute Deviation (MAD)	10.77855
Skewness	7.5614316
Sum	286397.02
Variance	54877.798
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	65	0.7%
6.2208	43	0.4%
9.3312	38	0.4%
5.4432	32	0.3%
3.6288	32	0.3%
15.552	26	0.3%
12.4416	21	0.2%
7.2576	19	0.2%
3.1104	18	0.2%
9.072	11	0.1%
Other values (7277)	9689	96.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-6599.978	1	< 0.1%
-3839.9904	1	< 0.1%
-3701.8928	1	< 0.1%
-3399.98	1	< 0.1%
-2929.4845	1	< 0.1%
-2639.9912	1	< 0.1%
-2287.782	1	< 0.1%
-1862.3124	1	< 0.1%
-1850.9464	1	< 0.1%
-1811.0784	1	< 0.1%

Value	Count	Frequency (%)
8399.976	1	< 0.1%
6719.9808	1	< 0.1%
5039.9856	1	< 0.1%
4946.37	1	< 0.1%
4630.4755	1	< 0.1%
3919.9888	1	< 0.1%
3177.475	1	< 0.1%
2799.984	1	< 0.1%
2591.9568	1	< 0.1%
2504.2216	1	< 0.1%

no_of_days_for_shipping
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.9581749

Minimum	0
Maximum	7
Zeros	519
Zeros (%)	5.2%
Negative	0
Negative (%)	0.0%
Memory size	414.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3
median	4
Q3	5
95-th percentile	7
Maximum	7
Range	7
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.7475667
Coefficient of variation (CV)	0.44150822
Kurtosis	-0.28755198
Mean	3.9581749
Median Absolute Deviation (MAD)	1
Skewness	-0.42132235
Sum	39558
Variance	3.0539895
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
4	2774	27.8%
5	2169	21.7%
2	1334	13.3%
6	1203	12.0%
3	1005	10.1%
7	621	6.2%
0	519	5.2%
1	369	3.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	519	5.2%
1	369	3.7%
2	1334	13.3%
3	1005	10.1%
4	2774	27.8%
5	2169	21.7%
6	1203	12.0%
7	621	6.2%

Value	Count	Frequency (%)
7	621	6.2%
6	1203	12.0%
5	2169	21.7%
4	2774	27.8%
3	1005	10.1%
2	1334	13.3%
1	369	3.7%
0	519	5.2%

sale_price_per_unit
Real number (ℝ)

Distinct	5006
Distinct (%)	50.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	60.862121

Minimum	-0.356
Maximum	3772.9967
Zeros	0
Zeros (%)	0.0%
Negative	2
Negative (%)	< 0.1%
Memory size	414.2 KiB

Quantile statistics

Minimum	-0.356
5-th percentile	1.82
Q1	5.402
median	16.236
Q3	63.8845
95-th percentile	243.9618
Maximum	3772.9967
Range	3773.3527
Interquartile range (IQR)	58.4825

Descriptive statistics

Standard deviation	142.93014
Coefficient of variation (CV)	2.3484253
Kurtosis	197.79112
Mean	60.862121
Median Absolute Deviation (MAD)	13.333
Skewness	10.78231
Sum	608256.04
Variance	20429.026
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.48	158	1.6%
5.98	49	0.5%
5.117333333	39	0.4%
6.48	38	0.4%
2.88	36	0.4%
5.084	36	0.4%
6.68	33	0.3%
4.13	32	0.3%
29.99	30	0.3%
4.28	30	0.3%
Other values (4996)	9513	95.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.356	1	< 0.1%
-0.244	1	< 0.1%
0.036	1	< 0.1%
0.076	1	< 0.1%
0.092	1	< 0.1%
0.09333333333	1	< 0.1%
0.098	1	< 0.1%
0.136	1	< 0.1%
0.1493333333	1	< 0.1%
0.152	1	< 0.1%

Value	Count	Frequency (%)
3772.996667	1	< 0.1%
3499.99	1	< 0.1%
3499.99	2	< 0.1%
2799.942	1	< 0.1%
2399.892	1	< 0.1%
2099.894	1	< 0.1%
1999.87	1	< 0.1%
1995.99	1	< 0.1%
1889.99	1	< 0.1%
1749.99	1	< 0.1%

profit_per_unit
Real number (ℝ)

Distinct	4246
Distinct (%)	42.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.7993719

Minimum	-1319.9956
Maximum	1679.9952
Zeros	65
Zeros (%)	0.7%
Negative	1871
Negative (%)	18.7%
Memory size	414.2 KiB

Quantile statistics

Minimum	-1319.9956
5-th percentile	-15.7514
Q1	0.7228
median	2.767
Q3	8.7032
95-th percentile	44.9985
Maximum	1679.9952
Range	2999.9908
Interquartile range (IQR)	7.9804

Descriptive statistics

Standard deviation	56.074974
Coefficient of variation (CV)	7.1896781
Kurtosis	355.61647
Mean	7.7993719
Median Absolute Deviation (MAD)	3.1531
Skewness	7.6224049
Sum	77946.923
Variance	3144.4027
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.1104	125	1.3%
1.8144	104	1.0%
0	65	0.7%
3.1104	51	0.5%
3.2064	25	0.3%
7.745	23	0.2%
5.7716	22	0.2%
0.9512	22	0.2%
1.4112	22	0.2%
3.4357	21	0.2%
Other values (4236)	9514	95.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1319.9956	2	< 0.1%
-959.9976	1	< 0.1%
-679.996	1	< 0.1%
-585.8969	1	< 0.1%
-462.7366	2	< 0.1%
-381.297	2	< 0.1%
-326.6376	1	< 0.1%
-314.9982	1	< 0.1%
-301.8464	1	< 0.1%
-296.0067	1	< 0.1%

Value	Count	Frequency (%)
1679.9952	3	< 0.1%
997.995	1	< 0.1%
979.9972	1	< 0.1%
926.0951	1	< 0.1%
635.495	4	< 0.1%
626.0554	1	< 0.1%
559.9968	2	< 0.1%
557.256	2	< 0.1%
548.0971	1	< 0.1%
421.5853	5	0.1%

purchase_price_per_unit
Real number (ℝ)

Distinct	6078
Distinct (%)	60.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	53.062749

Minimum	0.4544
Maximum	4074.8431
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	414.2 KiB

Quantile statistics

Minimum	0.4544
5-th percentile	1.60808
Q1	3.4324
median	12.7859
Q3	54.522
95-th percentile	217.4069
Maximum	4074.8431
Range	4074.3887
Interquartile range (IQR)	51.0896

Descriptive statistics

Standard deviation	122.24696
Coefficient of variation (CV)	2.3038188
Kurtosis	217.50886
Mean	53.062749
Median Absolute Deviation (MAD)	10.471833
Skewness	10.707819
Sum	530309.12
Variance	14944.319
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.3696	89	0.9%
3.3696	51	0.5%
3.3696	36	0.4%
3.2696	32	0.3%
3.302933333	32	0.3%
3.4736	25	0.3%
3.8743	21	0.2%
17.039	20	0.2%
3.3196	19	0.2%
6.5084	19	0.2%
Other values (6068)	9650	96.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.4544	1	< 0.1%
0.4778333333	2	< 0.1%
0.5042	1	< 0.1%
0.5258285714	1	< 0.1%
0.5445	2	< 0.1%
0.5445	1	< 0.1%
0.5544	2	< 0.1%
0.5544	1	< 0.1%
0.5572	1	< 0.1%
0.5708666667	1	< 0.1%

Value	Count	Frequency (%)
4074.843067	1	< 0.1%
2959.8676	1	< 0.1%
2219.8926	1	< 0.1%
2219.8526	1	< 0.1%
2219.6426	1	< 0.1%
1819.9948	1	< 0.1%
1819.9948	2	< 0.1%
1819.9448	1	< 0.1%
1819.8948	1	< 0.1%
1572.0288	2	< 0.1%

purchase_price
Real number (ℝ)

Distinct	7642
Distinct (%)	76.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	201.0449

Minimum	0.5544
Maximum	24449.058
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	414.2 KiB

Quantile statistics

Minimum	0.5544
5-th percentile	3.8964
Q1	12.4967
median	41.577
Q3	181.9095
95-th percentile	862.80072
Maximum	24449.058
Range	24448.504
Interquartile range (IQR)	169.4128

Descriptive statistics

Standard deviation	550.82677
Coefficient of variation (CV)	2.7398196
Kurtosis	454.60542
Mean	201.0449
Median Absolute Deviation (MAD)	35.1384
Skewness	14.753314
Sum	2009242.7
Variance	303410.13
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.7392	43	0.4%
10.1088	38	0.4%
9.9088	32	0.3%
6.5392	32	0.3%
16.848	26	0.3%
13.4784	21	0.2%
13.2784	19	0.2%
3.3696	18	0.2%
20.0176	10	0.1%
7.7486	10	0.1%
Other values (7632)	9745	97.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.5544	1	< 0.1%
0.64	2	< 0.1%
0.6572	1	< 0.1%
0.6736	1	< 0.1%
0.7012	1	< 0.1%
0.736	1	< 0.1%
0.7484	1	< 0.1%
0.754	1	< 0.1%
0.84	1	< 0.1%
0.8812	1	< 0.1%

Value	Count	Frequency (%)
24449.0584	1	< 0.1%
11839.4704	1	< 0.1%
11099.263	1	< 0.1%
9519.544	1	< 0.1%
9099.974	1	< 0.1%
7860.144	1	< 0.1%
7279.9792	1	< 0.1%
7279.7792	1	< 0.1%
7279.5792	1	< 0.1%
6733.9482	1	< 0.1%

weekday_string
Categorical

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	962.7 KiB

Wednesday	1593
Tuesday	1566
Friday	1562
Saturday	1429
Thursday	1415
Other values (2)	2429

Length

Max length	9
Median length	8
Mean length	7.2040224
Min length	6

Characters and Unicode

Total characters	71997
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Friday
2nd row	Friday
3rd row	Thursday
4th row	Sunday
5th row	Sunday

Common Values

Value	Count	Frequency (%)
Wednesday	1593	15.9%
Tuesday	1566	15.7%
Friday	1562	15.6%
Saturday	1429	14.3%
Thursday	1415	14.2%
Monday	1241	12.4%
Sunday	1188	11.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
wednesday	1593	15.9%
tuesday	1566	15.7%
friday	1562	15.6%
saturday	1429	14.3%
thursday	1415	14.2%
monday	1241	12.4%
sunday	1188	11.9%

Most occurring characters

Value	Count	Frequency (%)
d	11587	16.1%
a	11423	15.9%
y	9994	13.9%
u	5598	7.8%
e	4752	6.6%
s	4574	6.4%
r	4406	6.1%
n	4022	5.6%
T	2981	4.1%
S	2617	3.6%
Other values (7)	10043	13.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	62003	86.1%
Uppercase Letter	9994	13.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
d	11587	18.7%
a	11423	18.4%
y	9994	16.1%
u	5598	9.0%
e	4752	7.7%
s	4574	7.4%
r	4406	7.1%
n	4022	6.5%
i	1562	2.5%
t	1429	2.3%
Other values (2)	2656	4.3%

Uppercase Letter

Value	Count	Frequency (%)
T	2981	29.8%
S	2617	26.2%
W	1593	15.9%
F	1562	15.6%
M	1241	12.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	71997	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
d	11587	16.1%
a	11423	15.9%
y	9994	13.9%
u	5598	7.8%
e	4752	6.6%
s	4574	6.4%
r	4406	6.1%
n	4022	5.6%
T	2981	4.1%
S	2617	3.6%
Other values (7)	10043	13.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	71997	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
d	11587	16.1%
a	11423	15.9%
y	9994	13.9%
u	5598	7.8%
e	4752	6.6%
s	4574	6.4%
r	4406	6.1%
n	4022	5.6%
T	2981	4.1%
S	2617	3.6%
Other values (7)	10043	13.9%

year
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	931.5 KiB

2017	3345
2016	2578
2015	2131
2014	1940

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	39976
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2016
2nd row	2016
3rd row	2016
4th row	2015
5th row	2015

Common Values

Value	Count	Frequency (%)
2017	3345	33.5%
2016	2578	25.8%
2015	2131	21.3%
2014	1940	19.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2017	3345	33.5%
2016	2578	25.8%
2015	2131	21.3%
2014	1940	19.4%

Most occurring characters

Value	Count	Frequency (%)
2	9994	25.0%
0	9994	25.0%
1	9994	25.0%
7	3345	8.4%
6	2578	6.4%
5	2131	5.3%
4	1940	4.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	39976	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	9994	25.0%
0	9994	25.0%
1	9994	25.0%
7	3345	8.4%
6	2578	6.4%
5	2131	5.3%
4	1940	4.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	39976	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	9994	25.0%
0	9994	25.0%
1	9994	25.0%
7	3345	8.4%
6	2578	6.4%
5	2131	5.3%
4	1940	4.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	39976	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	9994	25.0%
0	9994	25.0%
1	9994	25.0%
7	3345	8.4%
6	2578	6.4%
5	2131	5.3%
4	1940	4.9%

month
Real number (ℝ)

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.7893736

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	414.2 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	5
median	9
Q3	11
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.3229042
Coefficient of variation (CV)	0.42659453
Kurtosis	-0.98257695
Mean	7.7893736
Median Absolute Deviation (MAD)	2
Skewness	-0.4376743
Sum	77847
Variance	11.041692
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
12	1449	14.5%
11	1436	14.4%
9	1356	13.6%
10	831	8.3%
6	764	7.6%
7	721	7.2%
5	694	6.9%
8	674	6.7%
4	653	6.5%
3	652	6.5%
Other values (2)	764	7.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	440	4.4%
2	324	3.2%
3	652	6.5%
4	653	6.5%
5	694	6.9%
6	764	7.6%
7	721	7.2%
8	674	6.7%
9	1356	13.6%
10	831	8.3%

Value	Count	Frequency (%)
12	1449	14.5%
11	1436	14.4%
10	831	8.3%
9	1356	13.6%
8	674	6.7%
7	721	7.2%
6	764	7.6%
5	694	6.9%
4	653	6.5%
3	652	6.5%

month_name
Categorical

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	956.3 KiB

December	1449
November	1436
September	1356
October	831
June	764
Other values (7)	4158

Length

Max length	9
Median length	7
Mean length	6.5403242
Min length	3

Characters and Unicode

Total characters	65364
Distinct characters	26
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	November
2nd row	November
3rd row	June
4th row	October
5th row	October

Common Values

Value	Count	Frequency (%)
December	1449	14.5%
November	1436	14.4%
September	1356	13.6%
October	831	8.3%
June	764	7.6%
July	721	7.2%
May	694	6.9%
August	674	6.7%
April	653	6.5%
March	652	6.5%
Other values (2)	764	7.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
december	1449	14.5%
november	1436	14.4%
september	1356	13.6%
october	831	8.3%
june	764	7.6%
july	721	7.2%
may	694	6.9%
august	674	6.7%
april	653	6.5%
march	652	6.5%
Other values (2)	764	7.6%

Most occurring characters

Value	Count	Frequency (%)
e	13206	20.2%
r	7465	11.4%
b	5396	8.3%
m	4241	6.5%
u	3597	5.5%
c	2932	4.5%
t	2861	4.4%
a	2550	3.9%
o	2267	3.5%
y	2179	3.3%
Other values (16)	18670	28.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	55370	84.7%
Uppercase Letter	9994	15.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	13206	23.9%
r	7465	13.5%
b	5396	9.7%
m	4241	7.7%
u	3597	6.5%
c	2932	5.3%
t	2861	5.2%
a	2550	4.6%
o	2267	4.1%
y	2179	3.9%
Other values (8)	8676	15.7%

Uppercase Letter

Value	Count	Frequency (%)
J	1925	19.3%
D	1449	14.5%
N	1436	14.4%
S	1356	13.6%
M	1346	13.5%
A	1327	13.3%
O	831	8.3%
F	324	3.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	65364	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	13206	20.2%
r	7465	11.4%
b	5396	8.3%
m	4241	6.5%
u	3597	5.5%
c	2932	4.5%
t	2861	4.4%
a	2550	3.9%
o	2267	3.5%
y	2179	3.3%
Other values (16)	18670	28.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	65364	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	13206	20.2%
r	7465	11.4%
b	5396	8.3%
m	4241	6.5%
u	3597	5.5%
c	2932	4.5%
t	2861	4.4%
a	2550	3.9%
o	2267	3.5%
y	2179	3.3%
Other values (16)	18670	28.6%

Auto

Heatmap
Table

	sales	quantity	discount	profit	no_of_days_for_shipping	sale_price_per_unit	profit_per_unit	purchase_price_per_unit	purchase_price	month	ship_mode	segment	state	region	category	sub-category	weekday_string	year	month_name
sales	1.000	0.327	-0.057	0.518	-0.015	0.935	0.470	0.911	0.976	0.016	0.000	0.002	0.000	0.000	0.072	0.142	0.012	0.000	0.008
quantity	0.327	1.000	-0.001	0.234	0.016	-0.007	0.000	-0.005	0.321	0.024	0.000	0.012	0.004	0.000	0.000	0.000	0.001	0.015	0.011
discount	-0.057	-0.001	1.000	-0.543	-0.014	-0.070	-0.553	0.087	0.088	-0.002	0.027	0.005	0.354	0.294	0.377	0.353	0.017	0.000	0.007
profit	0.518	0.234	-0.543	1.000	-0.007	0.460	0.953	0.324	0.385	0.016	0.005	0.000	0.017	0.021	0.056	0.130	0.006	0.000	0.000
no_of_days_for_shipping	-0.015	0.016	-0.014	-0.007	1.000	-0.024	-0.015	-0.023	-0.014	0.004	0.781	0.043	0.102	0.041	0.000	0.001	0.141	0.046	0.053
sale_price_per_unit	0.935	-0.007	-0.070	0.460	-0.024	1.000	0.505	0.972	0.913	0.008	0.019	0.000	0.026	0.000	0.099	0.186	0.007	0.008	0.012
profit_per_unit	0.470	0.000	-0.553	0.953	-0.015	0.505	1.000	0.367	0.339	0.012	0.014	0.000	0.041	0.022	0.068	0.164	0.014	0.000	0.014
purchase_price_per_unit	0.911	-0.005	0.087	0.324	-0.023	0.972	0.367	1.000	0.938	0.006	0.022	0.000	0.000	0.010	0.062	0.176	0.015	0.000	0.013
purchase_price	0.976	0.321	0.088	0.385	-0.014	0.913	0.339	0.938	1.000	0.014	0.000	0.000	0.000	0.005	0.045	0.128	0.012	0.000	0.000
month	0.016	0.024	-0.002	0.016	0.004	0.008	0.012	0.006	0.014	1.000	0.049	0.036	0.097	0.043	0.000	0.000	0.049	0.021	1.000
ship_mode	0.000	0.000	0.027	0.005	0.781	0.019	0.014	0.022	0.000	0.049	1.000	0.033	0.096	0.022	0.000	0.007	0.105	0.021	0.050
segment	0.002	0.012	0.005	0.000	0.043	0.000	0.000	0.000	0.000	0.036	0.033	1.000	0.090	0.000	0.000	0.000	0.038	0.027	0.037
state	0.000	0.004	0.354	0.017	0.102	0.026	0.041	0.000	0.000	0.097	0.096	0.090	1.000	0.998	0.019	0.000	0.103	0.089	0.101
region	0.000	0.000	0.294	0.021	0.041	0.000	0.022	0.010	0.005	0.043	0.022	0.000	0.998	1.000	0.000	0.000	0.060	0.021	0.046
category	0.072	0.000	0.377	0.056	0.000	0.099	0.068	0.062	0.045	0.000	0.000	0.000	0.019	0.000	1.000	0.999	0.000	0.000	0.000
sub-category	0.142	0.000	0.353	0.130	0.001	0.186	0.164	0.176	0.128	0.000	0.007	0.000	0.000	0.000	0.999	1.000	0.000	0.000	0.000
weekday_string	0.012	0.001	0.017	0.006	0.141	0.007	0.014	0.015	0.012	0.049	0.105	0.038	0.103	0.060	0.000	0.000	1.000	0.046	0.053
year	0.000	0.015	0.000	0.000	0.046	0.008	0.000	0.000	0.000	0.021	0.021	0.027	0.089	0.021	0.000	0.000	0.046	1.000	0.028
month_name	0.008	0.011	0.007	0.000	0.053	0.012	0.014	0.013	0.000	1.000	0.050	0.037	0.101	0.046	0.000	0.000	0.053	0.028	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	order_id	order_date	ship_date	ship_mode	customer_id	customer_name	segment	city	state	region	product_id	category	sub-category	product_name	sales	quantity	discount	profit	no_of_days_for_shipping	sale_price_per_unit	profit_per_unit	purchase_price_per_unit	purchase_price	weekday_string	year	month	month_name
0	CA-2016-152156	2016-11-08	2016-11-11	Second Class	CG-12520	Claire Gute	Consumer	Henderson	Kentucky	South	FUR-BO-10001798	Furniture	Bookcases	Bush Somerset Collection Bookcase	261.96000	2	0.00000	41.91360	3	130.98000	20.95680	110.02320	220.04640	Friday	2016	11	November
1	CA-2016-152156	2016-11-08	2016-11-11	Second Class	CG-12520	Claire Gute	Consumer	Henderson	Kentucky	South	FUR-CH-10000454	Furniture	Chairs	Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back	731.94000	3	0.00000	219.58200	3	243.98000	73.19400	170.78600	512.35800	Friday	2016	11	November
2	CA-2016-138688	2016-06-12	2016-06-16	Second Class	DV-13045	Darrin Van Huff	Corporate	Los Angeles	California	West	OFF-LA-10000240	Office Supplies	Labels	Self-Adhesive Address Labels for Typewriters by Universal	14.62000	2	0.00000	6.87140	4	7.31000	3.43570	3.87430	7.74860	Thursday	2016	6	June
3	US-2015-108966	2015-10-11	2015-10-18	Standard Class	SO-20335	Sean O'Donnell	Consumer	Fort Lauderdale	Florida	South	FUR-TA-10000577	Furniture	Tables	Bretford CR4500 Series Slim Rectangular Table	957.57750	5	0.45000	-383.03100	7	191.42550	-76.60620	268.03170	1340.15850	Sunday	2015	10	October
4	US-2015-108966	2015-10-11	2015-10-18	Standard Class	SO-20335	Sean O'Donnell	Consumer	Fort Lauderdale	Florida	South	OFF-ST-10000760	Office Supplies	Storage	Eldon Fold 'N Roll Cart System	22.36800	2	0.20000	2.51640	7	11.08400	1.25820	9.82580	19.65160	Sunday	2015	10	October
5	CA-2014-115812	2014-06-09	2014-06-14	Standard Class	BH-11710	Brosina Hoffman	Consumer	Los Angeles	California	West	FUR-FU-10001487	Furniture	Furnishings	Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood	48.86000	7	0.00000	14.16940	5	6.98000	2.02420	4.95580	34.69060	Saturday	2014	6	June
6	CA-2014-115812	2014-06-09	2014-06-14	Standard Class	BH-11710	Brosina Hoffman	Consumer	Los Angeles	California	West	OFF-AR-10002833	Office Supplies	Art	Newell 322	7.28000	4	0.00000	1.96560	5	1.82000	0.49140	1.32860	5.31440	Saturday	2014	6	June
7	CA-2014-115812	2014-06-09	2014-06-14	Standard Class	BH-11710	Brosina Hoffman	Consumer	Los Angeles	California	West	TEC-PH-10002275	Technology	Phones	Mitel 5320 IP Phone VoIP phone	907.15200	6	0.20000	90.71520	5	151.15867	15.11920	136.03947	816.23680	Saturday	2014	6	June
8	CA-2014-115812	2014-06-09	2014-06-14	Standard Class	BH-11710	Brosina Hoffman	Consumer	Los Angeles	California	West	OFF-BI-10003910	Office Supplies	Binders	DXL Angle-View Binders with Locking Rings by Samsill	18.50400	3	0.20000	5.78250	5	6.10133	1.92750	4.17383	12.52150	Saturday	2014	6	June
9	CA-2014-115812	2014-06-09	2014-06-14	Standard Class	BH-11710	Brosina Hoffman	Consumer	Los Angeles	California	West	OFF-AP-10002892	Office Supplies	Appliances	Belkin F5C206VTEL 6 Outlet Surge	114.90000	5	0.00000	34.47000	5	22.98000	6.89400	16.08600	80.43000	Saturday	2014	6	June

	order_id	order_date	ship_date	ship_mode	customer_id	customer_name	segment	city	state	region	product_id	category	sub-category	product_name	sales	quantity	discount	profit	no_of_days_for_shipping	sale_price_per_unit	profit_per_unit	purchase_price_per_unit	purchase_price	weekday_string	year	month	month_name
9984	CA-2015-100251	2015-05-17	2015-05-23	Standard Class	DV-13465	Dianna Vittorini	Consumer	Long Beach	New York	East	OFF-LA-10003766	Office Supplies	Labels	Self-Adhesive Removable Labels	31.50000	10	0.00000	15.12000	6	3.15000	1.51200	1.63800	16.38000	Saturday	2015	5	May
9985	CA-2015-100251	2015-05-17	2015-05-23	Standard Class	DV-13465	Dianna Vittorini	Consumer	Long Beach	New York	East	OFF-SU-10000898	Office Supplies	Supplies	Acme Hot Forged Carbon Steel Scissors with Nickel-Plated Handles, 3 7/8" Cut, 8"L	55.60000	4	0.00000	16.12400	6	13.90000	4.03100	9.86900	39.47600	Saturday	2015	5	May
9986	CA-2016-125794	2016-09-29	2016-10-03	Standard Class	ML-17410	Maris LaWare	Consumer	Los Angeles	California	West	TEC-AC-10003399	Technology	Accessories	Memorex Mini Travel Drive 64 GB USB 2.0 Flash Drive	36.24000	1	0.00000	15.22080	4	36.24000	15.22080	21.01920	21.01920	Monday	2016	10	October
9987	CA-2017-163629	2017-11-17	2017-11-21	Standard Class	RA-19885	Ruben Ausman	Corporate	Athens	Georgia	South	TEC-AC-10001539	Technology	Accessories	Logitech G430 Surround Sound Gaming Headset with Dolby 7.1 Technology	79.99000	1	0.00000	28.79640	4	79.99000	28.79640	51.19360	51.19360	Tuesday	2017	11	November
9988	CA-2017-163629	2017-11-17	2017-11-21	Standard Class	RA-19885	Ruben Ausman	Corporate	Athens	Georgia	South	TEC-PH-10004006	Technology	Phones	Panasonic KX - TS880B Telephone	206.10000	5	0.00000	55.64700	4	41.22000	11.12940	30.09060	150.45300	Tuesday	2017	11	November
9989	CA-2014-110422	2014-01-21	2014-01-23	Second Class	TB-21400	Tom Boeckenhauer	Consumer	Miami	Florida	South	FUR-FU-10001889	Furniture	Furnishings	Ultra Door Pull Handle	25.24800	3	0.20000	4.10280	2	8.34933	1.36760	6.98173	20.94520	Thursday	2014	1	January
9990	CA-2017-121258	2017-02-26	2017-03-03	Standard Class	DB-13060	Dave Brooks	Consumer	Costa Mesa	California	West	FUR-FU-10000747	Furniture	Furnishings	Tenex B1-RE Series Chair Mats for Low Pile Carpets	91.96000	2	0.00000	15.63320	5	45.98000	7.81660	38.16340	76.32680	Friday	2017	3	March
9991	CA-2017-121258	2017-02-26	2017-03-03	Standard Class	DB-13060	Dave Brooks	Consumer	Costa Mesa	California	West	TEC-PH-10003645	Technology	Phones	Aastra 57i VoIP phone	258.57600	2	0.20000	19.39320	5	129.18800	9.69660	119.49140	238.98280	Friday	2017	3	March
9992	CA-2017-121258	2017-02-26	2017-03-03	Standard Class	DB-13060	Dave Brooks	Consumer	Costa Mesa	California	West	OFF-PA-10004041	Office Supplies	Paper	It's Hot Message Books with Stickers, 2 3/4" x 5"	29.60000	4	0.00000	13.32000	5	7.40000	3.33000	4.07000	16.28000	Friday	2017	3	March
9993	CA-2017-119914	2017-05-04	2017-05-09	Second Class	CC-12220	Chris Cortes	Consumer	Westminster	California	West	OFF-AP-10002684	Office Supplies	Appliances	Acco 7-Outlet Masterpiece Power Center, Wihtout Fax/Phone Line Protection	243.16000	2	0.00000	72.94800	5	121.58000	36.47400	85.10600	170.21200	Tuesday	2017	5	May

Most frequently occurring

	order_id	order_date	ship_date	ship_mode	customer_id	customer_name	segment	city	state	region	product_id	category	sub-category	product_name	sales	quantity	discount	profit	no_of_days_for_shipping	sale_price_per_unit	profit_per_unit	purchase_price_per_unit	purchase_price	weekday_string	year	month	month_name	# duplicates
0	US-2014-150119	2014-04-23	2014-04-27	Standard Class	LB-16795	Laurel Beltran	Home Office	Columbus	Ohio	East	FUR-CH-10002965	Furniture	Chairs	Global Leather Highback Executive Chair with Pneumatic Height Adjustment, Black	281.37200	2	0.30000	-12.05880	4	140.53600	-6.02940	146.56540	293.13080	Sunday	2014	4	April	2

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common